The following instruction guides you through the process of setting up a data transfer. Customize options according to your needs. (see drag and drop (MySQL, Oracle, PostgreSQL, SQLite or SQL Server).
Source
Defines connection and database/schema for the source.
All the objects are selected in the Objects list by default.
If you do not want some objects to be transferred, just simply uncheck them.
With this option is on, only the checked objects will be transferred. However, if you add any new objects in the source database/schema after you create your data transfer profile, the newly added objects will not be transferred unless you manually modify the Objects list.
Chooses this option if you wish all the objects being transferred to the target database/schema, all newly added objects will also be transferred without amending the data transfer profile.
Target
Connection
Transfers your selected objects directly to the other database/schema. Chooses the connection and database/schema you wish to transfer to.File
Transfers your selected objects directly to a text file. You can select the Server Type, Version and Encoding for the file.